翻訳と辞書
Words near each other
・ Set Me Free (Jermaine Stewart album)
・ Set Me Free (Jermaine Stewart song)
・ Set Me Free (Marion Raven album)
・ Set Me Free (The Kinks song)
・ Set Me Free (Velvet Revolver song)
・ Set Me on Fire
・ SET Metro
・ Set My Love in Motion
・ Set My World on Fire
・ SET News
・ Set notation
・ Set of irons
・ Set of uniqueness
・ Set on You
・ Set operation
Set operations (SQL)
・ Set Osho
・ Set packing
・ Set partitioning in hierarchical trees
・ Set Persson
・ Set phrase
・ Set Phyo Wai
・ Set piece
・ Set piece (football)
・ Set Piece (novel)
・ Set Pieces
・ Set point
・ Set Poppius
・ Set redundancy compression
・ Set Sail


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

Set operations (SQL) : ウィキペディア英語版
Set operations (SQL)

==UNION operator==
In SQL the UNION clause combines the results of two SQL queries into a single table of all matching rows. The two queries must result in the same number of columns and compatible data types in order to unite. Any duplicate records are automatically removed unless UNION ALL is used.
UNION can be useful in data warehouse applications where tables aren't perfectly normalized.〔"a UNION ALL views technique for managing maintenance and performance in your large data warehouse environment ... This UNION ALL technique has saved many of my clients with issues related to time-sensitive database designs. These databases usually have an extremely volatile current timeframe, month, or day portion and the older data is rarely updated. Using different container DASD allocations, tablespaces, tables, and index definitions, the settings can be tuned for the specific performance considerations for these different volatility levels and update frequency situations." (Terabyte Data Warehouse Table Design Choices - Part 2 ) (URL accessed on July 25, 2006)〕 A simple example would be a database having tables sales2005 and sales2006 that have identical structures but are separated because of performance considerations. A UNION query could combine results from both tables.
Note that UNION does not guarantee the order of rows. Rows from the second operand may appear before, after, or mixed with rows from the first operand. In situations where a specific order is desired, ORDER BY must be used.
Note that UNION ALL may be much faster than plain UNION.

抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「Set operations (SQL)」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.